C:/Projekte/RAIS/ApplicationLogiLayer/RADEVSearch.cs

Go to the documentation of this file.

using System;
using System.Collections.Generic;
using System.Text;
using RAIS.Common.RADEVSearchClasses;

namespace RAIS.ApplicationLogicLayer
{
    public static class RADEVSearch
    {
        #region Criteria factory methods




        public static RADEVSearchCriteria CreateFacilityCriteria()
        {
            return new RADEVSearchCriteria("[RADEV Search Criteria - Facility]('{0}')", "Facility");
        }
        public static RADEVSearchCriteria CreateYearCriteria()
        {
            return new RADEVSearchCriteria("[RADEV Search Criteria - Year]('{0}','{1}')", "Year");
        }
        public static RADEVSearchCriteria CreateNarativeCriteria()
        {
            return new RADEVSearchCriteria("[RADEV Search Criteria - Narrative]('%{0}%')", "Narrative");
        }
        public static RADEVSearchCriteria CreateLessonsLearnedCriteria()
        {
            return new RADEVSearchCriteria("[RADEV Search Criteria - Lessons Learned]('%{0}%')", "LessonsLearned");
        }
        public static RADEVSearchCriteria CreateCorrecActionCriteria()
        {
            return new RADEVSearchCriteria("[RADEV Search Criteria - Correc Action]('%{0}%')", "Correc Action");
        }
        public static RADEVSearchCriteria CreateWholeBodyCriteria()
        {
            return new RADEVSearchCriteria("[RADEV Search Criteria - Whole Body]({0},{1})", "Whole Body");
        }
        public static RADEVSearchCriteria CreateSourceActivityCriteria()
        {
            return new RADEVSearchCriteria("[RADEV Search Criteria - Source Activity]({0},{1})", "Source Activity");
        }
        public static RADEVSearchCriteria CreateGeneralSectorCriteria()
        {
            return new RADEVSearchCriteria("[RADEV Search Criteria - General Sector]({0})", "General Sector");
        }
        public static RADEVSearchCriteria CreateSpecificPracticeCriteria()
        {
            return new RADEVSearchCriteria("[RADEV Search Criteria - Specific Practice]({0})", "Specific Practice");
        }
        public static RADEVSearchCriteria CreateWorkersCriteria()
        {
            return new RADEVSearchCriteria("[RADEV Search Criteria - Workers]()", "Workers");
        }
        public static RADEVSearchCriteria CreatePublicCriteria()
        {
            return new RADEVSearchCriteria("[RADEV Search Criteria - Public]()", "Public");
        }
        public static RADEVSearchCriteria CreatePatientsCriteria()
        {
            return new RADEVSearchCriteria("[RADEV Search Criteria - Patients]()", "Patients");
        }
        public static RADEVSearchCriteria CreateDeterministicEffectsCriteria()
        {
            return new RADEVSearchCriteria("[RADEV Search Criteria - Deterministic Effects]({0})", "Deterministic Effects");
        }
        public static RADEVSearchCriteria CreateHealthConsequencesCriteria()
        {
            return new RADEVSearchCriteria("[RADEV Search Criteria - Health Consequences]({0})", "Health Consequences");
        }
        public static RADEVSearchCriteria CreateDoseTypeCriteria()
        {
            return new RADEVSearchCriteria("[RADEV Search Criteria - Dose Type]({0})", "Dose Type");
        }
        public static RADEVSearchCriteria CreateRadiationNuclideCriteria()
        {
            return new RADEVSearchCriteria("[RADEV Search Criteria - Radiation Nuclide]({0})", "Radiation Nuclide");
        }
        public static RADEVSearchCriteria CreateCategoryCriteria()
        {
            return new RADEVSearchCriteria("[RADEV Search Criteria - Category]({0})", "Category");
        }
        public static RADEVSearchCriteria CreateExtentEventsCriteria()
        {
            return new RADEVSearchCriteria("[RADEV Search Criteria - Extent Events]({0})", "Extent Events");
        }
        public static RADEVSearchCriteria CreateResponseEventsCriteria()
        {
            return new RADEVSearchCriteria("[RADEV Search Criteria - Response Events]({0})", "Response Events");
        }
        public static RADEVSearchCriteria CreateConcequencesCriteria()
        {
            return new RADEVSearchCriteria("[RADEV Search Criteria - Concequences]({0})", "Concequences");
        }
        public static RADEVSearchCriteria CreateCauseCriteria()
        {
            return new RADEVSearchCriteria("[RADEV Search Criteria - Cause]({0})", "Cause");
        }
        public static Dictionary<int, string> GetSavedSearchCriterias()
        {
            return DataAccessLayer.RADEVSearch.GetValueList("[RADEV Search List - Saved Criterias]()");
        }

        #endregion
        #region Dictionary loaders





        public static Dictionary<int, string> GetFacilityList(int userId)
        {
            return DataAccessLayer.RADEVSearch.GetValueList(string.Format("(SELECT [PK Facility ID] [ID],[Facility Name] [Name] FROM ufn_GetAllowedFacilitiesByUserID({0})) Facility", userId));
        }
        public static Dictionary<int, string> GetSpecificPracticeList(string categoryID)
        {
            return DataAccessLayer.RADEVSearch.GetValueList(string.Format("[RADEV Search List - Specific Practice]({0})", categoryID));
        }
        public static Dictionary<int, string> GetDeterministicEffectsList()
        {
            return DataAccessLayer.RADEVSearch.GetValueList("[RADEV Search List - Deterministic Effects]()");
        }
        public static Dictionary<int, string> GetHealthConsequencesList()
        {
            return DataAccessLayer.RADEVSearch.GetValueList("[RADEV Search List - Health Consequences]()");
        }
        public static Dictionary<int, string> GetDoseTypeList()
        {
            return DataAccessLayer.RADEVSearch.GetValueList("[RADEV Search List - Dose Type]()");
        }
        public static Dictionary<int, string> GetRadiationNuclideList()
        {
            return DataAccessLayer.RADEVSearch.GetValueList("[RADEV Search List - Radiation Nuclide]()");
        }
        public static Dictionary<int, string> GetCategoryList()
        {
            return DataAccessLayer.RADEVSearch.GetValueList("[RADEV Search List - Category]()");
        }
        public static Dictionary<int, string> GetGeneralSectorList()
        {
            return DataAccessLayer.RADEVSearch.GetValueList("[RADEV Search List - General Sector]()");
        }
        public static Dictionary<int, string> GetExtentEventsList()
        {
            Dictionary<int, string> ret = DataAccessLayer.RADEVSearch.GetValueList("[RADEV Search List - Extent Events]()");
            ret.Remove(-1);
            return ret;
        }
        public static Dictionary<int, string> GetResponseEventsList()
        {
            return DataAccessLayer.RADEVSearch.GetValueList("[RADEV Search List - Response Events]()");
        }
        public static Dictionary<int, string> GetConcequencesList()
        {
            return DataAccessLayer.RADEVSearch.GetValueList("[RADEV Search List - Concequences]()");
        }
        public static Dictionary<int, string> GetCauseList()
        {
            return DataAccessLayer.RADEVSearch.GetValueList("[RADEV Search List - Cause]()");
        }
        #endregion
        #region Public methods





        public static void SaveSearchCriterias(string name, string searchString)
        {
            DataAccessLayer.RADEVSearch.SaveSearchCriterias(name, searchString);
        }
        public static Dictionary<int, string> GetRadevIDs(int userID) {
            return DataAccessLayer.RADEVSearch.GetValueListFromQuery(string.Format(" SELECT [PK Radiation Events ID] AS [ID], " +
                                                            "    [Radiation Event Number] AS [Name] " +
                                                            " FROM " +
                                                            "    [Radiation Events]"+
                                                            "WHERE dbo.ufn_IsAccessRestrictionInvolvedFacility([FK Involved Facility ID], [FK Licencee Facility ID], {0}) = 1", userID));
        }
        #endregion
    }
}